SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52205 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52205 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995597,530130,378067,841221,671292,840498,217824,332359,200543,652449,108590,916721,439387,466671,571793,828503,178553,6767,546425,469491,949786,938148,983550,819781,625696,583886,319472,98767,515793,788842,833379,2037,37995,259929,804620,534820,64042,590733,207052,561973,708756,393737,705251,494136,1039637,366250,1025702,679724,476294,815343,904376,655805,857888,164662,616,25316,358277,352963,689734,43451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]