SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004761s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192513 LIMIT 1 [ RunTime:0.002306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192513 [ RunTime:0.004135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334858,1012836,366117,698580,63221,594022,589672,684088,165793,55487,493577,428777,664513,491839,857561,850374,169382,685358,183706,951857,245646,373955,247504,513820,252912,467006,30056,27069,633984,648310,434131,42552,268374,242507,210370,37607,870034,902722,588922,517681,298378,796120,69210,381975,125413,530532,422384,540961,9642,434697,552538,312583,164787,32357,198913,920989,525908,248538,663014,333123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003405s ]