SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106718 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106718 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31313,365382,568741,1035722,405335,14450,289373,616913,891433,206793,994033,591953,758936,893506,778261,181398,122651,176460,380981,833035,508506,8408,39470,846439,558870,91494,109065,389816,853604,733891,65230,524667,120749,727472,203346,246668,1011400,994420,659873,219534,8624,43281,175530,723756,880177,574405,496025,229081,173318,934992,500888,341070,327621,198250,227880,732320,609798,106887,319638,546082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]