SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001941s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402392 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402392 [ RunTime:0.002949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579820,591976,136188,245083,616577,327890,354648,966891,373158,50625,89052,269242,769715,791792,233048,254129,1027012,1036562,367756,106069,959615,913119,779639,590780,393836,799477,581309,50516,584404,708101,230027,219473,470199,384789,869516,508023,687241,935203,844403,584151,878101,119738,184017,385920,365469,138608,6580,515050,623973,826987,586245,336383,346337,535745,457803,175013,772810,720126,1024657,1003061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]