SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385366 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385366 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336229,646172,31865,576940,328531,315515,22635,486917,159576,41489,288930,418769,801850,1048773,12361,678941,351595,436146,483171,7077,131185,280161,984159,546677,176626,226025,239227,1024185,150624,200175,77072,450721,873463,1023235,946784,1039754,762219,281322,955239,791865,636706,314432,624906,624014,878954,903271,921241,683854,3202,410716,181901,373862,411748,884453,687519,146266,652801,897486,205615,227261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]