SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563410 LIMIT 1 [ RunTime:0.001829s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563410 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572593,778795,409693,534016,212554,828464,331431,33419,688104,7436,580112,974778,213246,791982,34240,56358,284839,747960,451262,482740,790963,659361,957629,637799,760674,644209,271014,465812,512044,394361,727376,787090,691057,679171,256667,959961,23567,654279,458063,5614,123626,559547,604423,54959,898840,405903,5650,481335,819969,913768,698709,527900,268894,407640,988878,542585,705150,1000691,557273,835063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001439s ]