SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840482 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840482 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482662,806530,208474,508445,240081,474714,152115,369031,754262,208480,910274,822684,128587,175384,641912,139626,1015298,214705,85080,42467,659458,767057,185341,354930,100506,995173,226536,652742,865708,673824,1002898,888504,42241,22529,218476,259940,381332,747763,28277,273110,2841,48486,317021,681982,607325,789777,1001311,779609,935295,203100,295179,131591,949874,583692,682624,142134,555057,364797,162123,157019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]