SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10114 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10114 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847216,742179,574084,127974,578812,1020167,558802,110566,875622,513181,787925,428517,516663,534212,813959,1041291,422063,372414,287616,46989,1035091,886320,947286,790879,706292,153800,76687,917384,565847,146938,142753,761399,683655,751198,219148,350604,859193,918699,865957,349795,589426,317911,483864,43437,128574,1013116,624375,532969,274313,912017,946743,657942,889432,116119,764911,829142,228260,679505,754071,154977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001129s ]