SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499954 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499954 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515638,227435,810192,704151,537567,14524,683165,736945,985652,555313,426295,983108,201798,494255,31402,348585,501422,311000,151796,781307,737232,498164,98283,881878,286476,484156,652121,944748,862339,311624,636003,458533,894523,346831,351429,346920,138212,183184,198502,495130,308485,996358,395378,288133,37257,822049,860754,655659,19027,412821,911041,566109,393790,1033824,664013,513251,400447,413411,445232,14540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]