SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518731 LIMIT 1 [ RunTime:0.001227s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518731 [ RunTime:0.003165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195893,973770,451627,395190,1001725,225036,116876,117586,914191,895085,720638,412922,1006705,633207,368818,89551,80262,846791,241485,596406,195550,497303,1023766,639464,848086,566423,516873,1034698,162901,550233,516664,662974,130014,766857,848429,309623,502574,369481,13420,457747,68854,908959,305529,275486,587201,500378,816774,684513,571689,800553,911,2617,648936,719984,210028,186255,580686,92779,965934,88788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001869s ]