SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451727 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451727 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881562,54936,211337,478244,501771,581103,334855,152160,177690,270749,198020,742673,599643,224999,268140,258880,475820,552573,106405,1043700,80549,544410,1027006,486161,309350,1000604,419718,31189,12880,394958,674388,1030530,33459,900188,242815,518176,658606,134690,446563,638353,762572,744405,491111,927188,325555,600587,989003,366430,226659,535766,206907,447307,93314,762055,150393,498172,629769,683367,512910,877077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451727 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451727 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]