SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025668 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025668 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984874,235324,690704,72221,261209,663958,830786,739920,887128,646949,545830,398197,808145,270692,502440,1006160,540266,152424,659228,957793,137821,305088,767382,731137,812454,275865,686618,276269,548598,444668,331312,437806,710596,277061,471496,1012931,378126,525051,391839,640944,603029,85682,710365,238013,939866,661145,611053,866407,206071,769771,232683,313565,768549,73052,135426,391220,485624,655114,250215,983566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]