SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456716 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456716 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540787,447532,549502,37414,308898,274834,88557,385750,643523,167680,529771,519237,927321,567036,577816,481412,791209,980842,436914,460428,988833,517636,465604,522694,592080,333725,264186,471649,270299,120505,766275,266410,602504,801959,16821,53356,231484,656018,842532,433920,351782,608347,296030,475626,684702,172462,985720,739995,550693,376870,716696,1011956,824537,195655,538651,1039052,952884,752775,173450,581091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]