SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286112 LIMIT 1 [ RunTime:0.001122s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286112 [ RunTime:0.005249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507654,445159,587647,945754,690754,667916,931504,344607,444431,743158,1037853,208874,233320,797132,168386,40294,204685,990270,347276,791563,672113,569730,996325,645231,388152,655588,834723,560038,430499,401203,74906,584079,282682,674860,898439,672681,1034102,162043,144866,407325,953055,250285,175717,166569,450646,358110,682193,299247,235206,321999,66892,187495,348567,1021679,750146,736435,1026154,390173,853273,408545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]