SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016117 LIMIT 1 [ RunTime:0.002067s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016117 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98709,505131,356367,675847,910524,51478,682152,652686,89733,494485,921287,1025112,156821,1035336,748066,102811,314466,530068,242500,766222,334286,853157,136515,202012,404048,85002,908739,69678,897694,970128,205578,975339,999536,155540,895524,3243,146857,965812,621290,377523,105663,860925,1015148,393204,259088,574361,402398,674739,879410,830666,1013635,186464,262401,725644,13707,852422,746848,192587,762458,993952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000926s ]