SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139208 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139208 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5655,595172,323962,248458,921154,516363,1009450,722198,35011,310455,344717,1037759,385706,214443,996426,791543,665239,718624,603621,244809,382533,646693,617880,112662,419445,788135,82787,582650,833786,1035107,1043971,887392,934804,967351,436688,120819,341084,140839,329394,1022542,445434,271659,368892,476022,5800,772498,554508,375369,130252,370893,275443,1003781,832807,90606,925948,26928,1027034,800857,1027344,528131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]