SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455107 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455107 [ RunTime:0.004585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763520,621532,422461,94155,733055,536368,892227,49995,64415,1010806,624529,613426,316287,748812,1887,933940,880461,290110,1033649,791792,300275,191881,236572,36083,177010,631755,520212,483769,345998,424688,974255,949764,154827,558977,804543,377785,860942,351463,489171,396620,647802,224359,871171,379821,570850,470556,407053,750011,787727,354738,811693,443473,107337,34137,688747,6443,817856,27201,269136,985851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]