SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501373 LIMIT 1 [ RunTime:0.003097s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501373 [ RunTime:0.004831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783313,849322,563745,318736,734727,522301,475769,486508,749617,118254,521743,845392,500198,117940,480621,701499,56000,276739,81444,787818,757941,592558,1046309,572550,37845,127856,492808,165557,899195,441450,457943,551453,467354,397521,1025810,318192,613734,219003,598656,516747,172408,872686,126201,272484,582784,827073,883126,860288,956428,893234,862946,886532,744779,646932,373620,399333,272004,13947,27763,730985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]