SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001862s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44400 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44400 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446830,165682,322358,672290,855138,650081,802820,1037223,619840,426619,891897,750984,626886,908580,360715,267127,415157,372281,924157,200824,521969,114619,496599,717857,353359,147470,561647,238258,321915,920435,418832,690145,927341,872445,644171,481725,1014654,939067,297464,689875,64169,230477,24446,231754,448636,799568,529938,367564,793013,725711,604757,957534,953502,535141,651854,176281,165656,526034,370258,224610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]