SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5721 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5721 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70410,387963,56470,359171,127784,667211,606610,358821,701958,781717,309515,335024,205282,878943,31512,679062,814292,36917,315313,165671,109601,641230,379500,650966,444951,246453,8585,221112,511986,456116,231078,849673,505303,1040884,731645,1003420,546036,425477,459853,568772,1017540,236979,950266,320870,504035,92298,504103,151434,1043228,306269,758730,44013,485734,690846,609152,1011868,947312,325201,928597,877907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]