SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416698 LIMIT 1 [ RunTime:0.001123s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416698 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7141,684514,836239,446182,735896,917529,549992,335708,361772,467089,848375,323818,878243,693865,18108,508448,836588,450589,803300,529118,584816,976168,528027,896040,742720,262775,71404,113801,788919,611796,922065,72659,254127,451535,466590,551832,586994,406837,712339,263875,788518,221214,110087,221388,716053,845920,333552,138545,1044576,885534,849801,1019874,1013223,988547,956791,107230,643085,830523,436265,839107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]