SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336728 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336728 [ RunTime:0.001298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710410,858272,1014828,531191,641342,871737,622837,1031180,564259,473524,376799,13545,769591,972093,165216,387119,638849,413416,144320,120731,550886,91925,50510,408411,560374,116982,737353,374582,45282,201666,343517,270022,962370,207459,811262,780205,158065,201129,583745,47520,1017966,269239,815620,217779,983439,202351,84416,687208,1040234,229972,692697,864863,488611,258631,778559,791986,966688,62449,616497,845146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]