SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318927 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318927 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218213,771580,551280,954897,299543,970859,80375,638090,492944,837792,508593,296286,408701,634441,635080,591084,849583,342936,707258,331212,332008,40441,787856,259623,759508,148167,345435,471607,925419,955905,259942,130250,445415,668044,251929,1043326,47038,60186,277040,586898,622310,770646,173733,426349,1019610,70572,179629,96617,409385,501443,486659,1012095,608019,98954,572133,680537,672268,75551,546294,840349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]