SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014715 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014715 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866143,971398,591195,75314,669807,51515,398219,868497,767556,541414,823199,67185,11816,542899,89277,760316,334957,458000,607563,947204,829242,946031,568004,334009,902198,34917,74010,383990,230510,588713,399896,213177,791344,731874,952620,193736,154446,127474,1005042,529990,82670,949159,710385,563729,778355,912934,1004529,20404,897659,654280,542717,202605,596242,875672,851445,25828,23758,988799,18696,301429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]