SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031808 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031808 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39868,262090,721295,69468,22293,674994,982783,139688,898534,264401,732226,413807,148938,410035,788855,44224,993213,253460,400022,36481,1037399,407430,785699,799089,914217,327482,354031,215780,860254,1018243,1043482,144379,1010315,753927,576757,997201,88986,565362,216286,410480,478361,815692,413707,1022170,428490,503826,749531,692213,59377,205707,682710,587200,256536,20613,265339,207829,207602,833267,24171,941396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]