SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29104 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29104 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002697,476813,490626,460744,1037443,730273,367930,109732,7176,624370,579372,384662,479939,16080,324256,259933,55535,29016,151362,726554,961795,486411,460078,900800,590844,867956,368987,912580,670934,522776,845300,1027577,489012,891103,324351,177736,434334,246823,1034984,324419,201428,54405,273512,412402,445694,373658,356669,591073,744121,221443,448140,242410,520205,623090,238081,368431,425680,516924,84405,768893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002851s ]