SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334311 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334311 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47935,887383,408152,255804,279848,1043852,232865,890642,1033412,127481,84177,699684,781856,16557,919042,333283,460133,881278,406116,207228,536773,468698,697326,257841,428183,791385,759132,1014462,968875,823290,250394,452301,656535,1021070,570315,460587,533991,11306,597978,271605,937373,96668,395604,160103,593295,715758,90717,663438,758758,985751,44854,968636,155848,739505,259531,556807,284616,454209,587701,1017324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]