SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018893 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018893 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506237,293392,420994,909957,605837,584620,466429,796374,701882,428995,596473,34038,906212,547951,68640,948849,524717,476635,384362,891395,541117,197473,95520,9923,1001837,469003,813546,141759,632582,694712,917536,645965,795623,462610,892985,392731,1014170,398541,939261,194585,15989,1032635,735245,747146,586315,768031,435646,906797,536217,138515,303195,116153,94994,510226,644462,394918,459669,96306,171726,396752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]