SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002035s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456551 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456551 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025281,1019660,907586,233814,202614,788846,515814,544802,1008380,822043,547813,624039,347989,766109,976043,1039695,834476,747972,391021,409041,965576,858461,215630,122211,123177,105682,604035,384062,324005,752607,304288,197898,562602,458395,235472,815318,776817,603604,1007781,986829,579083,705780,72286,55882,10922,53317,799572,211575,302579,53106,448467,995108,317883,137648,228865,507639,346878,745533,986631,623434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]