SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317398 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317398 [ RunTime:0.008021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394667,774266,816134,58228,999666,756639,989706,95056,936528,251573,801205,328640,890748,217125,201808,146670,1021571,351473,119353,1048157,515670,1027743,81214,279711,800388,332561,34180,242950,1047034,20777,345475,8340,499301,143730,346946,317134,522450,242940,916807,56169,328277,587312,177251,105458,488290,156855,369527,506761,546880,1032084,886441,970240,145641,396781,210214,1029900,591644,771554,235858,607044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001257s ]