SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476073 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476073 [ RunTime:0.002795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579092,1006820,373079,28736,405346,576497,742589,323701,384098,509810,796794,653374,344920,833688,504440,194667,1048571,348256,195387,940386,792707,898797,338490,589192,297000,402549,641260,374945,20145,965285,437894,401125,609533,845088,977742,788283,565778,320349,953638,44973,313558,302600,502064,969551,636431,268157,172037,300119,255555,243131,490687,294563,773879,67303,723276,1004171,660637,340792,581703,1018092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]