SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541628 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541628 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109587,455732,982818,989237,744009,360355,381501,1034253,484266,488826,469626,660030,642999,136963,1028648,427828,610218,454565,367640,330114,545939,86763,483351,973231,911016,393819,477793,503263,640351,1028872,518301,48178,162785,750350,448650,505506,699775,960058,809969,1000913,196954,586998,21264,892520,880310,515747,825595,62869,143783,380326,59782,410148,992860,994264,577380,977716,392684,236687,677820,607384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]