SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803518 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803518 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312529,457438,25299,645915,923438,707950,441855,773048,274558,543755,347834,993144,167041,306803,424404,896125,417134,282907,209846,706527,37733,654181,773725,449473,930326,150380,629253,364850,746404,514651,371238,1047934,3580,233177,833853,295033,188747,657431,754229,166441,832,13808,934491,849730,306730,130823,727187,524678,984094,526642,471249,35510,647565,584245,725588,860901,388083,61718,906950,1043945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000952s ]