SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468288 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468288 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398550,402315,935111,95155,34241,880421,526883,15849,939781,386227,810959,1017181,998533,947875,479311,641113,965396,763775,53057,157830,1048329,666904,155577,442133,128645,755060,518310,132727,550460,558679,360060,206249,221726,974836,963387,382238,503270,641016,315183,1016488,775406,235845,718032,665461,1028699,5872,292990,141860,449963,648332,455491,606847,738976,859009,909486,388463,356813,78046,373548,876704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]