SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103982 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103982 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459446,495712,375529,571277,792027,377001,1033348,552609,123450,139504,187443,1016156,234801,1041327,757245,287914,662187,772194,111769,1042541,132742,834869,349781,880091,160630,329921,868918,639856,438843,750095,904650,49913,809558,384326,887740,511847,491251,1043509,880505,83728,27447,731780,70901,544207,308976,767033,865667,703599,341914,933520,744778,369287,437618,931916,839505,75744,495249,725,221259,16693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]