SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565036 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565036 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837184,750129,651351,149289,786624,528963,351197,450277,818639,668926,345964,147978,972353,86666,105949,390472,45568,785012,1035528,360416,51312,338643,618717,263790,837097,403546,235566,424011,586170,949451,760509,920445,677274,602507,917989,635559,34551,754805,200731,398207,276620,898883,270388,41583,74213,26214,716163,181562,409261,357,271183,9689,25697,551079,78816,140331,588571,376962,439637,82942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]