SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017612 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017612 [ RunTime:0.003573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708175,648640,112784,743845,475118,815080,51034,477287,700285,664073,318620,901193,470200,852081,813905,1000335,649352,389775,221569,323894,74151,1040080,53602,829771,392193,747891,551748,591957,993738,281757,679830,788278,103440,171230,550423,367706,827303,902115,326512,456257,26224,386424,446756,681606,107138,893219,855283,438058,761066,371700,322217,301347,100649,792012,712243,279635,535590,70993,495121,694695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003153s ]