SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807584 LIMIT 1 [ RunTime:0.001118s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807584 [ RunTime:0.002023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879562,20898,67831,35916,14842,808511,609064,4966,450332,1003202,1027374,527255,815460,1034174,500559,310763,1007624,481355,181107,174351,516790,186811,1014400,780776,6247,45146,477811,345112,8321,548815,193535,119921,53227,1015045,537886,313048,272171,313251,822953,765002,441540,753595,1016021,218276,74404,172265,196692,490406,50148,350718,571459,335244,648479,411824,768290,540436,902634,691117,315603,927521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001874s ]