SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048539 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048539 [ RunTime:0.004509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042723,389706,556647,54121,926573,210516,364969,584378,706489,73441,573923,272467,689093,161906,339739,525990,400992,390204,844907,641105,665935,861118,80980,696420,358463,329053,390974,914640,393864,389709,529627,487482,665887,367590,370815,332502,662267,593266,867521,984244,348443,595050,46626,752686,895700,329477,73598,686720,561483,431852,837581,1022144,705711,580766,120341,55732,487488,18966,355972,800290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]