SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509681 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509681 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472361,628254,193239,146,600143,292270,877477,514336,366226,261369,17439,363188,844777,671503,352995,531191,242187,10381,721634,196262,968230,26812,272646,699488,936979,616693,467614,335943,220320,964657,339339,597619,977396,467852,258884,926029,142316,432977,710843,900434,267871,670921,107584,85393,513823,674296,594250,774872,733924,488329,899258,801895,166062,753361,1012205,739508,57524,891850,600445,600949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]