SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44142 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44142 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487459,104560,297316,540368,537220,629505,327287,224212,18289,259478,220442,55808,953694,973669,486292,727895,52990,540322,775325,879896,343676,566790,1037415,658434,740299,611896,503182,745352,1038164,18816,722820,255237,195250,640262,644864,81509,122433,433275,512780,807240,986136,661359,924638,155248,868782,316077,415167,334270,1029785,616463,23125,326144,207928,542817,747629,812308,648675,244196,537067,170350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]