SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46398 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46398 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586013,751031,1041496,876884,361160,926580,482270,143058,623621,160694,306583,822482,147431,793856,297009,313798,433179,684099,722621,474230,899210,708896,241921,139709,777716,199973,971153,825459,656819,189240,765000,389381,854430,937165,1015789,553353,11945,815150,319293,225518,549403,521178,760296,166225,288943,24766,154110,120323,855320,59560,559561,1021751,344247,85902,52399,812816,526597,538025,385998,182649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]