SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333213 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333213 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710724,938941,249537,625795,254298,655866,691141,566982,549415,100351,765990,180597,549627,783728,880842,705089,894480,327098,926884,226500,964298,20186,808779,976094,22854,696636,773902,301528,202305,92924,923348,390282,543504,753677,677695,642556,443275,440779,325673,525561,314165,177387,789492,673461,646816,704694,165558,244950,598829,56734,764151,761130,690851,828892,643713,112734,462356,499608,591681,969642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]