SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470907 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470907 [ RunTime:0.004922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496592,1033253,445856,684492,11239,379824,979099,113710,351753,514189,97435,288292,845724,701219,700680,398657,131253,750661,702064,927158,554133,851142,259040,306562,987500,670015,1019348,148394,697319,91846,668493,917326,565897,639784,367360,830304,387624,601424,472625,318578,831082,1008513,1031562,115694,178413,737461,367786,871691,891309,446818,852803,918382,1011844,937331,54419,465210,228503,74344,367719,420707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]