SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28427 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28427 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006886,722947,616869,57964,899088,777141,46095,311642,252789,384390,274739,414338,306944,727997,546369,379720,689316,742175,338298,1027100,521957,422330,537233,545368,110185,861932,149604,561124,653425,114336,625554,57463,766017,309404,511087,805337,554588,805119,130459,488883,503301,62314,22477,500909,237986,965797,775213,801624,975149,141265,700233,266776,595343,187294,30446,198034,960863,116030,552403,911327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]