SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 66448 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 66448 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767250,624561,496579,997133,187358,142151,612764,103911,998249,429559,469306,64834,783345,42980,322616,618079,863735,510491,238307,685489,793576,177467,383939,10848,247792,140839,848448,66953,495468,904279,1009594,35679,543650,723706,498673,199184,302224,245084,309697,52695,32355,672750,920316,118601,581413,430549,235892,637327,797363,903422,604060,898047,858624,33631,758389,99824,321183,940621,964523,810543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 66448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 66448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]