SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508743 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508743 [ RunTime:0.003923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341771,292649,173992,1038050,868772,890534,293055,353736,129368,560268,952333,856068,736103,882212,474793,968290,498126,265864,870370,46135,309571,413635,886469,421686,1002514,384181,796061,394529,812940,264069,712895,524536,464964,260046,136371,412245,551489,830237,913427,30142,292732,352674,764422,860965,133734,781337,407370,890367,147200,517820,776361,246409,670128,259946,845326,682828,616573,971759,138616,198188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]