SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418391 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418391 [ RunTime:0.002887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930735,816632,1041722,896685,145341,169406,910589,470174,95244,200894,466981,771561,467901,571282,203621,24797,667024,344604,428568,579566,897024,501550,371303,456905,896497,289095,1033789,640612,473621,752823,870760,404046,45622,987414,863557,386929,133537,1043363,657326,936220,164101,852917,124287,950847,108985,651363,33337,402496,968704,693625,568695,867505,943989,296103,113948,886168,676373,417370,473960,926714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]