SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040884 LIMIT 1 [ RunTime:0.000811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040884 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257419,519419,874443,820965,338576,35251,191360,382258,2895,283567,617375,835021,321902,881679,365363,696036,927909,321203,681810,887446,165062,859552,145111,804328,535563,272044,986224,799416,626325,616335,136941,471009,871571,753571,127893,627488,870768,999877,838392,248801,888945,1015105,304640,470691,553616,448093,841715,510110,826994,149581,223405,956753,852940,297903,704431,618196,884675,576140,698427,1015612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]