SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589051 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589051 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983391,599283,698717,113704,232282,748720,1534,661117,467802,736348,588273,973201,195335,65212,1004212,627802,736282,479439,525525,955174,6994,795454,90670,544013,715655,329193,1041160,689403,1026902,252730,479976,864712,553999,891864,1011824,428664,95359,143549,1035967,1033608,489674,997339,549113,563981,931500,620550,647427,458101,474807,192792,98456,808125,177628,217641,574703,446702,822333,312537,134400,926644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]