SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514213 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514213 [ RunTime:0.005202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377281,1037973,415459,885563,683966,370338,30034,38329,530030,664453,125523,464302,506704,937943,93828,931953,932062,621298,322852,451485,959589,521009,1040740,548908,517909,378215,701048,783282,349566,440607,962569,157110,130808,35273,454972,601147,175613,93398,642691,210699,573240,336517,890227,940142,429829,743312,568219,251554,132075,540045,536008,282151,408689,609668,180521,619292,304082,85317,448387,822584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]