SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433616 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433616 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899977,1015480,711850,949904,108673,231032,383583,662266,819994,705143,623090,799258,362285,463639,351694,216806,395531,660059,295614,136650,228390,226941,454399,630773,820103,1028149,526006,848455,695654,870497,722395,474577,787328,17606,77242,470046,549625,280911,1000652,820219,702592,277653,765380,63300,631858,970105,606936,261534,741285,286891,316981,216266,978660,115741,279811,241348,902113,550161,214667,402588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]