SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255323 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255323 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778158,4204,8783,161179,595220,783835,848611,324450,368385,229068,489797,934771,391515,966911,787332,480613,1016035,397092,302772,324999,532481,972709,885969,944887,848610,402489,574623,780051,103145,850786,569443,417613,660634,135514,260616,692,454133,524377,895014,118617,439195,878862,739316,144630,945879,579845,499257,804402,517283,405072,952267,520807,685490,727773,925457,327021,322058,189321,758250,806021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001437s ]