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` = 203180 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203180 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382444,251103,583523,700731,784198,217505,498463,524276,823053,721175,73433,875710,535760,988620,89444,625189,51133,639863,421031,180311,816647,516182,570162,456122,841013,823914,656054,806255,356451,613034,636901,687223,729220,916328,115705,133656,688141,5561,1041676,386348,80680,6809,794065,279688,973239,444138,650424,447309,710347,39468,380524,83272,188629,685585,1034729,984045,180769,992679,604215,28394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]