SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190890 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190890 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022605,113905,953116,683074,380987,175992,639124,147301,494385,265629,440346,242310,66580,38336,49844,593938,1009028,611996,970182,760090,861245,477287,617218,474120,559806,479505,942108,32817,558113,794664,215341,882663,920581,694292,659785,148311,1010261,369622,105907,737617,268121,937036,142406,888397,806050,402320,867251,386455,713676,45808,289235,939106,449946,959811,905324,490942,719649,580983,122782,1030743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]