SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528057 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528057 [ RunTime:0.002896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956153,596958,976882,30315,849787,348725,1556,952692,335370,372771,177405,657185,708118,300570,688567,357214,951538,187912,578798,295895,347458,178670,504651,35386,427405,193386,79155,920070,250265,857511,715975,939213,1011125,973375,323441,502633,898705,748068,1028972,192929,21088,880196,976552,548522,373785,664523,205725,787287,966824,869596,191318,200761,222973,855136,872081,154541,607437,759573,499505,744156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]