SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421351 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421351 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545757,85703,246567,679561,268445,353209,487640,764033,1044200,304288,465130,138325,160784,446380,36506,127424,571070,532099,97779,49976,806748,57177,566317,989021,194865,201797,167714,561262,469346,658755,503159,522785,987249,353408,926663,540112,451182,983325,526115,199876,263296,608377,744282,453409,938759,649281,677873,402260,905838,829543,303420,72823,1028730,682948,57608,206349,874960,421521,966468,614114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]