SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 177004 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 177004 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512557,459688,648999,1013020,808359,352093,573741,390798,946343,512110,419555,1011151,724640,390838,160728,134196,98279,522795,619952,186949,229164,911855,778879,869652,978241,751002,135511,686589,142767,321311,871117,118717,971406,513553,827211,772606,716089,111405,461649,720206,281632,399127,63743,215072,587694,209205,22121,354626,362379,163068,490555,565857,44211,478540,984294,505032,852350,993546,951070,145574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 177004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 177004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]