SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403597 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403597 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832377,736386,559933,553210,763381,845850,255777,738424,770453,527213,24710,749901,443228,182731,644240,587358,158369,656373,456844,513722,252642,557090,325289,976165,581756,9822,309573,270527,327110,447120,602226,250978,351735,852947,444903,1001323,932209,788911,833666,290044,834195,124942,337458,296482,517314,823729,206391,158741,869453,72059,243571,937699,759683,308088,446950,488791,19294,363321,416440,566649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]