SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 15450 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 15450 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021575,469601,787110,1004014,154938,460396,1014295,418280,278460,61202,106404,503762,717051,885173,434270,685934,935337,799005,406100,419544,1018339,132786,239815,291728,643386,284604,785678,318171,589648,622328,674159,470073,397915,1002968,368097,153607,738656,346626,161813,661393,379033,432578,48589,486487,614456,1009003,431747,198840,787312,335669,49507,803248,838978,875778,910182,505208,626071,162052,763101,894068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 15450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 15450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]