SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555674 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555674 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042003,438819,953390,418984,754697,422976,984442,399673,830763,912821,428634,46005,906047,616509,239376,632635,764623,324305,165270,1048346,209944,277934,944821,284416,346848,1048649,591777,239765,1042434,626457,960508,720542,309539,1024567,338953,521578,379329,310862,221195,559778,8799,780753,1039875,1009101,135525,321116,594939,348656,193719,606080,149119,993623,616344,455474,603752,1024571,148419,1042057,474604,551055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]