SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001879s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012785 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012785 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419281,320985,438370,723490,528131,775278,329895,112103,671465,1022430,813657,947759,619325,768607,528778,760013,62398,106083,822320,456098,175673,471271,672795,866289,311142,931851,863566,736899,615094,695622,180788,538971,533491,88981,273683,533402,177826,748653,231903,771497,594327,475669,791161,644109,947685,1027899,729514,1025092,601267,825585,556424,252077,327181,177617,132597,1028054,804616,671686,317717,786814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]