SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38479 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38479 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519681,319890,237501,1015045,633285,576936,1025349,328228,14627,722683,566351,438943,188546,79185,25218,345471,993986,276170,141676,126889,283453,841102,973621,141275,222896,678595,526723,415912,459507,1039028,79957,544880,597376,49741,137753,1022854,443681,677492,74019,622444,882320,274296,809009,74825,1042493,874255,820441,798925,217755,399496,340797,420070,115337,118403,626316,55236,25925,970687,843836,669737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]