SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813560 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813560 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17358,398594,712251,44275,586580,887354,184019,544411,233123,417230,403289,392418,493704,743327,887816,385393,941578,656042,272429,579337,255968,239052,517031,838221,833790,771237,708388,409480,86399,995647,762460,137889,471191,514474,441262,55517,205462,435574,716663,404721,277314,427400,10789,907532,737157,224156,695710,274958,724206,546102,315654,589669,129354,743059,766571,256659,1033129,269339,364706,599136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]