SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317142 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317142 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019623,101979,314306,488048,706767,575187,697884,54078,102403,101542,819383,745441,32510,582433,694010,1022824,28382,957272,601314,171229,309731,599068,1010429,776018,258268,111330,218342,782734,991514,227816,687255,812035,502654,13960,990685,1047768,845282,833526,895900,328262,355297,1007521,392558,137611,882036,347510,89724,325304,880920,443886,819203,838698,49381,828392,652255,509361,786624,1023558,93270,642906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]