SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465213 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465213 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519092,493432,190300,325402,489496,420786,721667,79750,204701,251573,952327,591972,589107,664369,176642,814840,764411,282103,187336,727125,542047,271101,547924,128211,360239,477713,852550,232688,552413,72384,679891,903001,44807,522642,803852,293335,82996,840639,1020372,156230,803075,989716,428761,1043122,953008,476032,610741,850941,374725,589973,938208,387972,648481,624831,609451,310155,19235,727971,328780,331166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001947s ]