SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596483 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596483 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515626,90480,902314,869800,351585,969546,47834,121534,65180,112859,65673,684051,815591,535806,749888,949090,367375,861806,413588,854918,119027,511295,612787,233098,112692,632446,166882,161836,814864,627597,349296,341386,970039,179801,662112,44613,318768,899072,837870,538277,1043035,489254,101138,211951,828221,503525,49114,95758,298903,339055,818977,987900,424121,631462,865495,751550,591928,1592,822397,692851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]