SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39593 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39593 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400905,476614,709048,70764,180797,707230,855378,434908,189489,246624,649862,689425,7069,180137,1030050,951712,243068,615731,1001707,66525,681891,181897,132427,681948,619038,521102,835824,739909,711764,616267,255739,681611,554568,648460,146873,682464,329577,325728,461009,1014357,870833,540563,890731,1010244,821562,677252,219026,88962,658206,67180,359299,856171,417824,344175,471166,672179,897026,535521,990512,769371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]