SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406957 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406957 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412176,274414,314313,894039,792391,67770,132588,332915,481918,771310,334151,497920,72055,148952,965804,928114,169988,982297,270490,620233,872222,752737,104867,327729,473621,920435,1036810,151216,1353,99899,701322,859451,978962,357353,458301,267665,944689,407117,615772,834379,148646,266155,991847,40051,330269,42531,106439,277581,502097,1025860,599844,534302,611435,960247,957315,455018,744859,516121,458905,982028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]