SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427176 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427176 [ RunTime:0.002402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498138,1041992,132902,450185,247014,649651,741061,183405,477848,21299,129349,527165,850976,126057,141938,166581,952590,517004,541933,890328,934325,323860,986406,383422,996799,783143,337733,398946,487326,129844,506557,257881,603520,782608,982350,547140,700882,296945,779685,534387,338410,42316,762286,940021,811242,67931,815714,279693,686474,625648,927491,243198,929436,25357,726246,359635,164596,342930,376655,786419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001710s ]