SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416493 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416493 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107077,668760,272283,600725,185084,127156,876680,528073,129309,178652,135473,683765,504656,213015,591988,24954,238165,620519,630235,576792,165565,429663,156941,769783,838014,955751,320083,801984,824664,251450,120938,444398,824846,558749,654813,169790,170698,561155,1024163,916562,969120,917194,74742,326234,234471,997683,247156,209972,991584,552815,288157,962504,493595,908962,459492,711451,138965,1023232,262552,219823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]