SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035592 LIMIT 1 [ RunTime:0.000920s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035592 [ RunTime:0.005472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467692,971287,778064,329441,936419,927843,241251,437328,43915,451565,141784,1034640,272618,281590,321186,602899,235036,540725,1032033,347650,35690,500664,65691,1025257,20661,298007,453469,75670,173705,543517,559480,976375,535443,334833,414777,958786,893482,924304,630201,1045624,97385,179002,1036785,309548,176992,866607,924637,219185,970869,237662,687095,384074,597480,439083,168428,657342,79857,385972,20529,379468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]