SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39301 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39301 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226817,65262,503328,57242,440660,320123,81401,684935,667815,789688,991531,482920,100472,118007,559720,1045189,520530,393580,412721,545556,448718,246497,471642,404006,695503,588202,355994,96398,328299,964812,314348,443455,232967,850458,555135,902437,850070,273960,628644,643524,263755,185186,100516,957731,1001127,836152,12772,196714,754900,295567,916806,578878,566764,335198,728373,566009,302033,538912,157063,343411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]