SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201794 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201794 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383140,533729,839712,467593,597308,754588,802537,220689,788459,485668,863153,110814,760831,821028,673863,634268,251405,864491,411114,919065,289177,1041467,727208,786654,202464,38378,375291,628474,984314,1036752,898905,884306,469695,62761,658944,1037810,29423,709961,69259,193208,912474,719822,157700,226328,797064,443978,589645,479191,895816,752431,750865,444686,761037,513842,221602,16489,428859,735879,1016909,563807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]