SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328801 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328801 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354519,938917,656256,909264,313351,399900,492877,659544,592466,700122,221522,443442,441667,106533,369638,116243,433999,729936,926994,996956,958027,237421,1008734,961238,411170,302412,488233,432115,871453,351550,53507,813440,175280,343224,39301,32261,919931,142224,596814,274503,485597,34274,414804,549653,62115,940189,691915,185445,351688,72576,261236,995705,280742,440125,210210,602582,887739,677019,356724,1014547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]